#!/bin/bash

mysql -uroot -p123123 <<EOF
  create database jd;
  use jd;
  create table reshuihu(id int(5),name varchar(20),size varchar(4),color varchar(10),price decimal(10));
  insert into reshuihu(id,name,size,color,price) values(1,'madia','5L','red',320);
  insert into reshuihu(id,name,size,color,price) values(2,'gree','2L','blue',89);
  select * from reshuihu;
  exit
EOF
